//package com.mapper;
//
//import com.pojo.Employee;
//import org.apache.ibatis.annotations.*;
//
//@Mapper
//public interface EmployeeMapper {
//    // 新增员工（自动回填主键）
//    @Insert("INSERT INTO employee (name, workstation_id, status, create_time) " +
//            "VALUES (#{name}, #{workstationId}, #{status}, #{createTime})")
//    @Options(useGeneratedKeys = true, keyProperty = "id")
//    void insert(Employee employee);
//
//    // 根据ID查询员工详情（自动映射驼峰字段）
//    @Select("SELECT " +
//            "id, name, " +
//            "workstation_id AS workstationId, " +
//            "status, " +
//            "create_time AS createTime " +
//            "FROM employee WHERE id = #{id}")
//    Employee selectById(Integer id);
//
//    // 动态更新员工信息（支持部分字段更新）
//    @Update("<script>" +
//            "UPDATE employee " +
//            "<set>" +
//            "   <if test='name != null'>name = #{name},</if>" +
//            "   <if test='workstationId != null'>workstation_id = #{workstationId},</if>" +
//            "   <if test='status != null'>status = #{status},</if>" +
//            "   update_time = NOW()" +
//            "</set>" +
//            "WHERE id = #{id}" +
//            "</script>")
//    void updateById(Employee employee);
//}